{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Template","2011-12","2010-11"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Template","index":0,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["GST Reconciliations:   Bi-monthly GST Periods in 201_ /1_ Year "]
[]
[null,null,null,"Box","April / May","June / July","Aug / Sep","Oct / Nov","Dec / Jan","Feb / Mar",null,"Year to Date"]
["Sales & Income (Revenue)"]
[null,"Total Sales and Income"]
[null,null,"Debtors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger GST Return (Revenue)",null,0,0,0,0,0,0,null,0]
[null,null,"Total Sales and Income",5,0,0,0,0,0,0,null,0]
[null,"Zero Rated Supplies"]
[null,null,"Debtors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger Cash Sales",null,0,0,0,0,0,0,null,0]
[null,null,"Zero Rated Supplies included in Box 5",6,0,0,0,0,0,0,null,0]
[null,null,"Subtract Box 6 from Box 5",7,0,0,0,0,0,0,null,0]
[0.15,null,"GST on Revenue",8,0,0,0,0,0,0,null,0]
[null,null,"Adjustments",9,0,0,0,0,0,0,null,0]
[null,null,"Total GST Collected",10,0,0,0,0,0,0,null,0]
[]
["Purchases and Expenses"]
[null,"Total Purchases and Expenses"]
[null,null,"Creditors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger GST Return (Expenses)",null,0,0,0,0,0,0,null,0]
[null,null,"Total Purchases and Expenses",11,0,0,0,0,0,0,null,0]
[null,null,"GST on expenses / payments",12,0,0,0,0,0,0,null,0]
[null,null,"Credit Adjustments",13,0,0,0,0,0,0,null,0]
[null,null,"Total GST credit",14,0,0,0,0,0,0,null,0]
[]
[null,null,"NETT GST",15,0,0,0,0,0,0,null,0]
[{"$nulls":4},"GST to pay","GST to pay","GST to pay","GST to pay","GST to pay","GST to pay"]
[]
[null,null,"Less Payment already made",null,0,0,0,0,0,0,null,0]
[null,null,"Payment that still needs to be made",null,0,0,0,0,0,0,null,0]
[]
[]
[null,"Cross-Check"]
[null,null,"Net Taxable Revenue less Expenses",null,0,0,0,0,0,0,null,0]
[null,null,"GST on this",null,0,0,0,0,0,0,null,0]
[null,null,"Net Adjustments",null,0,0,0,0,0,0,null,0]
[null,null,"Cross-Check on GST to Pay or Refund",null,0,0,0,0,0,0,null,0]
[{"$nulls":4},"","","","","","",null,""]

{"sheet":"2011-12","index":1,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["GST Reconciliations:   Bi-monthly GST Periods in 2011 /12 Year "]
[]
[null,null,null,"Box","April / May","June / July","Aug / Sep","Oct / Nov","Dec / Jan","Feb / Mar",null,"Year to Date"]
["Sales & Income (Revenue)"]
[null,"Total Sales and Income"]
[null,null,"Debtors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger GST Return (Revenue)",null,0,0,0,0,0,0,null,0]
[null,null,"Total Sales and Income",5,0,0,0,0,0,0,null,0]
[null,"Zero Rated Supplies"]
[null,null,"Debtors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger Cash Sales",null,0,0,0,0,0,0,null,0]
[null,null,"Zero Rated Supplies included in Box 5",6,0,0,0,0,0,0,null,0]
[null,null,"Subtract Box 6 from Box 5",7,0,0,0,0,0,0,null,0]
[0.15,null,"GST on Revenue",8,0,0,0,0,0,0,null,0]
[null,null,"Adjustments",9,0,0,0,0,0,0,null,0]
[null,null,"Total GST Collected",10,0,0,0,0,0,0,null,0]
[]
["Purchases and Expenses"]
[null,"Total Purchases and Expenses"]
[null,null,"Creditors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger GST Return (Expenses)",null,0,0,0,0,0,0,null,0]
[null,null,"Total Purchases and Expenses",11,0,0,0,0,0,0,null,0]
[null,null,"GST on expenses / payments",12,0,0,0,0,0,0,null,0]
[null,null,"Credit Adjustments",13,0,0,0,0,0,0,null,0]
[null,null,"Total GST credit",14,0,0,0,0,0,0,null,0]
[]
[null,null,"NETT GST",15,0,0,0,0,0,0,null,0]
[{"$nulls":4},"GST to pay","GST to pay","GST to pay","GST to pay","GST to pay","GST to pay"]
[]
[null,null,"Less Payment already made",null,0,0,0,0,0,0,null,0]
[null,null,"Payment that still needs to be made",null,0,0,0,0,0,0,null,0]
[]
[]
[null,"Cross-Check"]
[null,null,"Net Taxable Revenue less Expenses",null,0,0,0,0,0,0,null,0]
[null,null,"GST on this",null,0,0,0,0,0,0,null,0]
[null,null,"Net Adjustments",null,0,0,0,0,0,0,null,0]
[null,null,"Cross-Check on GST to Pay or Refund",null,0,0,0,0,0,0,null,0]
[{"$nulls":4},"","","","","","",null,""]

{"sheet":"2010-11","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,11]],"flags":["formulas_cached_only"]}
["GST Reconciliations:   Bi-monthly GST Periods in 2010 /11 Year "]
[]
[null,null,null,"Box","April / May","June / July","Aug / Sep","Oct / Nov","Dec / Jan","Feb / Mar",null,"Year to Date"]
["Sales & Income (Revenue)"]
[null,"Total Sales and Income"]
[null,null,"Debtors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger GST Return (Revenue)",null,0,0,0,0,0,0,null,0]
[null,null,"Total Sales and Income",5,0,0,0,0,0,0,null,0]
[null,"Zero Rated Supplies"]
[null,null,"Debtors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger Cash Sales",null,0,0,0,0,0,0,null,0]
[null,null,"Zero Rated Supplies included in Box 5",6,0,0,0,0,0,0,null,0]
[null,null,"Subtract Box 6 from Box 5",7,0,0,0,0,0,0,null,0]
[9,null,"GST on Revenue",8,0,0,0,0,0,0,null,0]
[null,null,"Adjustments",9,0,0,0,0,0,0,null,0]
[null,null,"Total GST Collected",10,0,0,0,0,0,0,null,0]
[]
["Purchases and Expenses"]
[null,"Total Purchases and Expenses"]
[null,null,"Creditors GST Report (Cash Basis) ",null,0,0,0,0,0,0,null,0]
[null,null,"General Ledger GST Return (Expenses)",null,0,0,0,0,0,0,null,0]
[null,null,"Total Purchases and Expenses",11,0,0,0,0,0,0,null,0]
[null,null,"GST on Expenses / Payments",12,0,0,0,0,0,0,null,0]
[null,null,"Credit Adjustments",13,0,0,0,0,0,0,null,0]
[null,null,"Total GST credit",14,0,0,0,0,0,0,null,0]
[]
[null,null,"NETT GST",15,0,0,0,0,0,0,null,0]
[{"$nulls":4},"GST to pay","GST to pay","GST to pay","GST to pay","GST to pay","GST to pay"]
[]
[null,null,"Less Payment already made",null,0,0,0,0,0,0,null,0]
[null,null,"Payment that still needs to be made",null,0,0,0,0,0,0,null,0]
[]
[]
[null,"Cross-Check"]
[null,null,"Net Taxable Revenue less Expenses",null,0,0,0,0,0,0,null,0]
[null,null,"GST on this",null,0,0,0,0,0,0,null,0]
[null,null,"Net Adjustments",null,0,0,0,0,0,0,null,0]
[null,null,"Cross-Check on GST to Pay or Refund",null,0,0,0,0,0,0,null,0]
[{"$nulls":4},"","","","","","",null,""]